package io.renren.modules.sys.dao;

import io.renren.modules.sys.entity.SysUserEntity;
import io.renren.modules.sys.entity.TiananEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * 提案
 *
 * @author Mark
 * @email sunlightcs@gmail.com
 * @date 2021-03-14 21:48:35
 */
@Mapper
public interface TiananDao extends BaseMapper<TiananEntity> {
    /**
     * 完结
     *
     * @return
     */
    Float over(String year);

    /**
     * 超时
     *
     * @return
     */
    Float overtime(String year);

    /**
     * 满意度
     *
     * @return
     */
    List<Map<String, String>> manyi(@Param("year")String year);

    /**
     * 类型
     *
     * @return
     */
    List<Map<String, String>> type(@Param("year")String year);

    /**
     * 类别
     *
     * @return
     */
    List<Map<String, String>> types(@Param("year")String year);

    /**
     * 类型
     *
     * @return
     */
    List<Map<String, String>> liantype(@Param("year")String year);

    /**
     * 部门个数
     *
     * @return
     */
    List<Map<String, String>> liandept(@Param("year")String year);

    /**
     * 人员个数
     *
     * @return
     */
    List<Map<String, String>> lianren(@Param("year")String year);

    void updateendtime(@Param("nowdate") Date nowdate,@Param("year")String year);

    List<String> listyear();


    List<SysUserEntity> listreuser();

    List<SysUserEntity> listleauser();




}
